﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace QuanLyThongTinNhanKhau.model.DAO
{
    class TKChungTuDAO
    {
        SQLServiceDAO service = new SQLServiceDAO();

        internal System.Data.DataTable btnThongKe(string fromDate, string toDate)
        {
            String sql = "select MaChungTu, c.MaNhanKhau, HoTen, GioiTinh, NoiThuongTru, NoiChet, NgayChet, NoiThuongTruCuoiCung, NguyenNhan from CHUNGTU c join NHANKHAU n on c.MaNhanKhau = n.MaNhanKhau where c.TinhTrang = 'Enable' and NgayChet >='" + fromDate + "' and NgayChet <='" + toDate + "' ";
            return service.getDataTable(sql);
        }
    }
}
